#!bin/bashimport_date=`date -d "-1 day" +%Y%m%d`echo import_date: $import_datesql="load data inpath '/user_clicks/${import_date}/clicklog.dat' overwrite into table lg.user_clicks partition (dt=${import_date});"echo sql: $sql/opt/bdp/hive-2.3.7/bin/hive -e "$sql"